Clear workspace

rm(list = ls())
library(bigrquery)
library(stringr)
library(tidyverse)
library(dplyr)
library(lme4)
library(MuMIn)
library(scales)
library(Hmisc)
response <- try(system('~/google-cloud-sdk/bin/gcloud projects list --quiet', intern = T))
projectid <- strsplit(response[3], " ")[[1]][1]
create_dataset <- function(poolname) {
  sql <- str_replace_all("SELECT 
    ##POOL_NAME##.percentage_of_regional_pool_present,
    ##POOL_NAME##.difference_from_locality_trait_gravity,
    ##POOL_NAME##.percentage_of_niches_present,
    ##POOL_NAME##.percentage_of_niches_2_present,
    ##POOL_NAME##.percentage_of_niches_3_present,
    latitude,
    longitude,
    percentage_landcover_5km.closed_forest_total AS closed_forest,
    percentage_landcover_5km.cultivated,
    percentage_landcover_5km.herbaceous_vegetation,
    percentage_landcover_5km.herbaceous_wetland,
    percentage_landcover_5km.open_forest_total AS open_forest,
    percentage_landcover_5km.permanent_water,
    percentage_landcover_5km.shrubs,
    percentage_landcover_5km.urban,
    percentage_landcover_5km.elevation.mean AS mean_elevation,
    percentage_landcover_5km.elevation.delta AS elevation_delta,
    average_population_density.within_5km AS average_population_density,
    urban_area.name AS city_name,
    urban_area.location.continent,
    urban_area.ecosystem.realm,
    urban_area.ecosystem.biome.biome_name AS biome,
    urban_area.country_economy.gdp_estimate_thousand_dollars_per_person AS national_gdp_estimate_thousand_dollars_per_person,
    urban_area.country_economy.income_group AS national_income_group,
    locality_id,
    number_of_checklists
FROM model.urban_hotspot
JOIN model2.all_species USING(locality_id, city_id)
JOIN model.urban_area USING (city_id)", '##POOL_NAME##', poolname)

  print(sql)
  
  tb <- bq_project_query(projectid, sql)

  bq_table_download(tb)
}
load_dataset <- function(poolname) {
  filename <- str_replace('download_data__output__hotspot_metrics_##POOL_NAME##.csv', '##POOL_NAME##', poolname)
  
  if (!file.exists(filename)) {
    data <- create_dataset(poolname)
    write_csv(data, filename)
  }
  
  data <- read_csv(filename)
  
  data$city_name = as.factor(data$city_name)
  data$continent = relevel(as.factor(data$continent), ref = "Europe")
  data$realm = relevel(as.factor(data$realm), ref = "Palearctic")
  data$biome = as.factor(data$biome)
  data$national_income_group = as.factor(data$national_income_group)
  data$mean_elevation_scaled = rescale(data$mean_elevation, to = c(0, 1), from = range(data$mean_elevation, na.rm = TRUE, finite = TRUE))
  data$elevation_delta_scaled = rescale(data$elevation_delta, to = c(0, 1), from = range(data$elevation_delta, na.rm = TRUE, finite = TRUE))
  data$average_population_density_scaled = rescale(data$average_population_density, to = c(0, 1), from = range(data$average_population_density, na.rm = TRUE, finite = TRUE))
  data$national_gdp_estimate_thousand_dollars_per_person_scaled = rescale(data$national_gdp_estimate_thousand_dollars_per_person, to = c(0, 1), from = range(data$national_gdp_estimate_thousand_dollars_per_person, na.rm = TRUE, finite = TRUE))
  data$latitude_scaled = rescale(data$latitude, to = c(0, 1), from = range(data$latitude, na.rm = TRUE, finite = TRUE))
  data$longitude_scaled = rescale(data$longitude, to = c(0, 1), from = range(data$longitude, na.rm = TRUE, finite = TRUE))
  data$absolute_latitude_scaled = abs(data$latitude_scaled)
  data$number_of_checklists_sqrt = sqrt(data$number_of_checklists)
  data$number_of_checklists_scaled = rescale(data$number_of_checklists_sqrt, to = c(0, 1), from = range(data$number_of_checklists_sqrt, na.rm = TRUE, finite = TRUE))
  data
}

Merlin

merlin <- load_dataset('merlin')

── Column specification ─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
cols(
  .default = col_double(),
  city_name = col_character(),
  continent = col_character(),
  realm = col_character(),
  biome = col_character(),
  national_income_group = col_character(),
  locality_id = col_character()
)
ℹ Use `spec()` for the full column specifications.
merlin

Birdlife

birdlife <- load_dataset('birdlife')

── Column specification ─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
cols(
  .default = col_double(),
  city_name = col_character(),
  continent = col_character(),
  realm = col_character(),
  biome = col_character(),
  national_income_group = col_character(),
  locality_id = col_character()
)
ℹ Use `spec()` for the full column specifications.
birdlife
library("PerformanceAnalytics")
rcorr(as.matrix(birdlife[,c('closed_forest', 'cultivated', 'herbaceous_vegetation', 'herbaceous_wetland', 'open_forest', 'permanent_water', 'shrubs', 'urban')],  method="spearman"))
                      closed_forest cultivated herbaceous_vegetation herbaceous_wetland open_forest permanent_water shrubs urban
closed_forest                  1.00      -0.06                 -0.20              -0.12        0.37           -0.06  -0.24 -0.31
cultivated                    -0.06       1.00                  0.02               0.00        0.01           -0.07  -0.01 -0.15
herbaceous_vegetation         -0.20       0.02                  1.00               0.07        0.14           -0.08   0.09 -0.11
herbaceous_wetland            -0.12       0.00                  0.07               1.00       -0.04            0.06  -0.10 -0.14
open_forest                    0.37       0.01                  0.14              -0.04        1.00           -0.09  -0.05 -0.23
permanent_water               -0.06      -0.07                 -0.08               0.06       -0.09            1.00  -0.14 -0.26
shrubs                        -0.24      -0.01                  0.09              -0.10       -0.05           -0.14   1.00 -0.06
urban                         -0.31      -0.15                 -0.11              -0.14       -0.23           -0.26  -0.06  1.00

n= 8443 


P
                      closed_forest cultivated herbaceous_vegetation herbaceous_wetland open_forest permanent_water shrubs urban 
closed_forest                       0.0000     0.0000                0.0000             0.0000      0.0000          0.0000 0.0000
cultivated            0.0000                   0.0503                0.8864             0.3930      0.0000          0.3228 0.0000
herbaceous_vegetation 0.0000        0.0503                           0.0000             0.0000      0.0000          0.0000 0.0000
herbaceous_wetland    0.0000        0.8864     0.0000                                   0.0000      0.0000          0.0000 0.0000
open_forest           0.0000        0.3930     0.0000                0.0000                         0.0000          0.0000 0.0000
permanent_water       0.0000        0.0000     0.0000                0.0000             0.0000                      0.0000 0.0000
shrubs                0.0000        0.3228     0.0000                0.0000             0.0000      0.0000                 0.0000
urban                 0.0000        0.0000     0.0000                0.0000             0.0000      0.0000          0.0000       

Both

both <- load_dataset('both')

── Column specification ─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
cols(
  .default = col_double(),
  city_name = col_character(),
  continent = col_character(),
  realm = col_character(),
  biome = col_character(),
  national_income_group = col_character(),
  locality_id = col_character()
)
ℹ Use `spec()` for the full column specifications.
both

Either

either <- load_dataset('either')

── Column specification ─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
cols(
  .default = col_double(),
  city_name = col_character(),
  continent = col_character(),
  realm = col_character(),
  biome = col_character(),
  national_income_group = col_character(),
  locality_id = col_character()
)
ℹ Use `spec()` for the full column specifications.
either
population_growth <- function(city_row) {
  population <- c(city_row$pop1950, city_row$pop1955, city_row$pop1960, city_row$pop1965, city_row$pop1970, city_row$pop1975, city_row$pop1980, city_row$pop1985, city_row$pop1990, city_row$pop1995, city_row$pop2000, city_row$pop2005, city_row$pop2010, city_row$pop2015, city_row$pop2020)
  years <- c(1950, 1955, 1960, 1965, 1970, 1975, 1980, 1985, 1990, 1995, 2000, 2005, 2010, 2015, 2020)
  
  model <- lm(population ~ years)
  model$coefficients[2]
}
city_data <- read_csv('download_data__input__city_data.csv')

── Column specification ─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
cols(
  .default = col_double(),
  name = col_character(),
  city_includes_estuary = col_logical(),
  region_100km_includes_estuary = col_logical(),
  region_50km_includes_estuary = col_logical(),
  region_20km_includes_estuary = col_logical(),
  biome_name = col_character(),
  realm = col_character()
)
ℹ Use `spec()` for the full column specifications.
city_data$realm <- as.factor(city_data$realm)
city_data$city_includes_estuary <- as.factor(city_data$city_includes_estuary)
city_data$region_100km_includes_estuary <- as.factor(city_data$region_100km_includes_estuary)
city_data$region_50km_includes_estuary <- as.factor(city_data$region_50km_includes_estuary)
city_data$region_20km_includes_estuary <- as.factor(city_data$region_20km_includes_estuary)
city_data$biome_name <- as.factor(city_data$biome_name)

city_data$population_growth = 0

for(i in 1:nrow(city_data)) {
    city_data[i,]$population_growth = population_growth(city_data[i,])
}

city_data
LS0tCnRpdGxlOiAiRG93bmxvYWQgbG9jYWxpdHkgZGF0YSIKb3V0cHV0OiBodG1sX25vdGVib29rCi0tLQoKQ2xlYXIgd29ya3NwYWNlCmBgYHtyfQpybShsaXN0ID0gbHMoKSkKYGBgCgpgYGB7cn0KbGlicmFyeShiaWdycXVlcnkpCmxpYnJhcnkoc3RyaW5ncikKbGlicmFyeSh0aWR5dmVyc2UpCmxpYnJhcnkoZHBseXIpCmxpYnJhcnkobG1lNCkKbGlicmFyeShNdU1JbikKbGlicmFyeShzY2FsZXMpCmxpYnJhcnkoSG1pc2MpCmBgYAoKYGBge3J9CnJlc3BvbnNlIDwtIHRyeShzeXN0ZW0oJ34vZ29vZ2xlLWNsb3VkLXNkay9iaW4vZ2Nsb3VkIHByb2plY3RzIGxpc3QgLS1xdWlldCcsIGludGVybiA9IFQpKQpwcm9qZWN0aWQgPC0gc3Ryc3BsaXQocmVzcG9uc2VbM10sICIgIilbWzFdXVsxXQpgYGAKICAKCmBgYHtyfQpjcmVhdGVfZGF0YXNldCA8LSBmdW5jdGlvbihwb29sbmFtZSkgewogIHNxbCA8LSBzdHJfcmVwbGFjZV9hbGwoIlNFTEVDVCAKICAgICMjUE9PTF9OQU1FIyMucGVyY2VudGFnZV9vZl9yZWdpb25hbF9wb29sX3ByZXNlbnQsCiAgICAjI1BPT0xfTkFNRSMjLmRpZmZlcmVuY2VfZnJvbV9sb2NhbGl0eV90cmFpdF9ncmF2aXR5LAogICAgIyNQT09MX05BTUUjIy5wZXJjZW50YWdlX29mX25pY2hlc19wcmVzZW50LAogICAgIyNQT09MX05BTUUjIy5wZXJjZW50YWdlX29mX25pY2hlc18yX3ByZXNlbnQsCiAgICAjI1BPT0xfTkFNRSMjLnBlcmNlbnRhZ2Vfb2ZfbmljaGVzXzNfcHJlc2VudCwKICAgIGxhdGl0dWRlLAogICAgbG9uZ2l0dWRlLAogICAgcGVyY2VudGFnZV9sYW5kY292ZXJfNWttLmNsb3NlZF9mb3Jlc3RfdG90YWwgQVMgY2xvc2VkX2ZvcmVzdCwKICAgIHBlcmNlbnRhZ2VfbGFuZGNvdmVyXzVrbS5jdWx0aXZhdGVkLAogICAgcGVyY2VudGFnZV9sYW5kY292ZXJfNWttLmhlcmJhY2VvdXNfdmVnZXRhdGlvbiwKICAgIHBlcmNlbnRhZ2VfbGFuZGNvdmVyXzVrbS5oZXJiYWNlb3VzX3dldGxhbmQsCiAgICBwZXJjZW50YWdlX2xhbmRjb3Zlcl81a20ub3Blbl9mb3Jlc3RfdG90YWwgQVMgb3Blbl9mb3Jlc3QsCiAgICBwZXJjZW50YWdlX2xhbmRjb3Zlcl81a20ucGVybWFuZW50X3dhdGVyLAogICAgcGVyY2VudGFnZV9sYW5kY292ZXJfNWttLnNocnVicywKICAgIHBlcmNlbnRhZ2VfbGFuZGNvdmVyXzVrbS51cmJhbiwKICAgIHBlcmNlbnRhZ2VfbGFuZGNvdmVyXzVrbS5lbGV2YXRpb24ubWVhbiBBUyBtZWFuX2VsZXZhdGlvbiwKICAgIHBlcmNlbnRhZ2VfbGFuZGNvdmVyXzVrbS5lbGV2YXRpb24uZGVsdGEgQVMgZWxldmF0aW9uX2RlbHRhLAogICAgYXZlcmFnZV9wb3B1bGF0aW9uX2RlbnNpdHkud2l0aGluXzVrbSBBUyBhdmVyYWdlX3BvcHVsYXRpb25fZGVuc2l0eSwKICAgIHVyYmFuX2FyZWEubmFtZSBBUyBjaXR5X25hbWUsCiAgICB1cmJhbl9hcmVhLmxvY2F0aW9uLmNvbnRpbmVudCwKICAgIHVyYmFuX2FyZWEuZWNvc3lzdGVtLnJlYWxtLAogICAgdXJiYW5fYXJlYS5lY29zeXN0ZW0uYmlvbWUuYmlvbWVfbmFtZSBBUyBiaW9tZSwKICAgIHVyYmFuX2FyZWEuY291bnRyeV9lY29ub215LmdkcF9lc3RpbWF0ZV90aG91c2FuZF9kb2xsYXJzX3Blcl9wZXJzb24gQVMgbmF0aW9uYWxfZ2RwX2VzdGltYXRlX3Rob3VzYW5kX2RvbGxhcnNfcGVyX3BlcnNvbiwKICAgIHVyYmFuX2FyZWEuY291bnRyeV9lY29ub215LmluY29tZV9ncm91cCBBUyBuYXRpb25hbF9pbmNvbWVfZ3JvdXAsCiAgICBsb2NhbGl0eV9pZCwKICAgIG51bWJlcl9vZl9jaGVja2xpc3RzCkZST00gbW9kZWwudXJiYW5faG90c3BvdApKT0lOIG1vZGVsMi5hbGxfc3BlY2llcyBVU0lORyhsb2NhbGl0eV9pZCwgY2l0eV9pZCkKSk9JTiBtb2RlbC51cmJhbl9hcmVhIFVTSU5HIChjaXR5X2lkKSIsICcjI1BPT0xfTkFNRSMjJywgcG9vbG5hbWUpCgogIHByaW50KHNxbCkKICAKICB0YiA8LSBicV9wcm9qZWN0X3F1ZXJ5KHByb2plY3RpZCwgc3FsKQoKICBicV90YWJsZV9kb3dubG9hZCh0YikKfQpgYGAKCgpgYGB7cn0KbG9hZF9kYXRhc2V0IDwtIGZ1bmN0aW9uKHBvb2xuYW1lKSB7CiAgZmlsZW5hbWUgPC0gc3RyX3JlcGxhY2UoJ2Rvd25sb2FkX2RhdGFfX291dHB1dF9faG90c3BvdF9tZXRyaWNzXyMjUE9PTF9OQU1FIyMuY3N2JywgJyMjUE9PTF9OQU1FIyMnLCBwb29sbmFtZSkKICAKICBpZiAoIWZpbGUuZXhpc3RzKGZpbGVuYW1lKSkgewogICAgZGF0YSA8LSBjcmVhdGVfZGF0YXNldChwb29sbmFtZSkKICAgIHdyaXRlX2NzdihkYXRhLCBmaWxlbmFtZSkKICB9CiAgCiAgZGF0YSA8LSByZWFkX2NzdihmaWxlbmFtZSkKICAKICBkYXRhJGNpdHlfbmFtZSA9IGFzLmZhY3RvcihkYXRhJGNpdHlfbmFtZSkKICBkYXRhJGNvbnRpbmVudCA9IHJlbGV2ZWwoYXMuZmFjdG9yKGRhdGEkY29udGluZW50KSwgcmVmID0gIkV1cm9wZSIpCiAgZGF0YSRyZWFsbSA9IHJlbGV2ZWwoYXMuZmFjdG9yKGRhdGEkcmVhbG0pLCByZWYgPSAiUGFsZWFyY3RpYyIpCiAgZGF0YSRiaW9tZSA9IGFzLmZhY3RvcihkYXRhJGJpb21lKQogIGRhdGEkbmF0aW9uYWxfaW5jb21lX2dyb3VwID0gYXMuZmFjdG9yKGRhdGEkbmF0aW9uYWxfaW5jb21lX2dyb3VwKQogIGRhdGEkbWVhbl9lbGV2YXRpb25fc2NhbGVkID0gcmVzY2FsZShkYXRhJG1lYW5fZWxldmF0aW9uLCB0byA9IGMoMCwgMSksIGZyb20gPSByYW5nZShkYXRhJG1lYW5fZWxldmF0aW9uLCBuYS5ybSA9IFRSVUUsIGZpbml0ZSA9IFRSVUUpKQogIGRhdGEkZWxldmF0aW9uX2RlbHRhX3NjYWxlZCA9IHJlc2NhbGUoZGF0YSRlbGV2YXRpb25fZGVsdGEsIHRvID0gYygwLCAxKSwgZnJvbSA9IHJhbmdlKGRhdGEkZWxldmF0aW9uX2RlbHRhLCBuYS5ybSA9IFRSVUUsIGZpbml0ZSA9IFRSVUUpKQogIGRhdGEkYXZlcmFnZV9wb3B1bGF0aW9uX2RlbnNpdHlfc2NhbGVkID0gcmVzY2FsZShkYXRhJGF2ZXJhZ2VfcG9wdWxhdGlvbl9kZW5zaXR5LCB0byA9IGMoMCwgMSksIGZyb20gPSByYW5nZShkYXRhJGF2ZXJhZ2VfcG9wdWxhdGlvbl9kZW5zaXR5LCBuYS5ybSA9IFRSVUUsIGZpbml0ZSA9IFRSVUUpKQogIGRhdGEkbmF0aW9uYWxfZ2RwX2VzdGltYXRlX3Rob3VzYW5kX2RvbGxhcnNfcGVyX3BlcnNvbl9zY2FsZWQgPSByZXNjYWxlKGRhdGEkbmF0aW9uYWxfZ2RwX2VzdGltYXRlX3Rob3VzYW5kX2RvbGxhcnNfcGVyX3BlcnNvbiwgdG8gPSBjKDAsIDEpLCBmcm9tID0gcmFuZ2UoZGF0YSRuYXRpb25hbF9nZHBfZXN0aW1hdGVfdGhvdXNhbmRfZG9sbGFyc19wZXJfcGVyc29uLCBuYS5ybSA9IFRSVUUsIGZpbml0ZSA9IFRSVUUpKQogIGRhdGEkbGF0aXR1ZGVfc2NhbGVkID0gcmVzY2FsZShkYXRhJGxhdGl0dWRlLCB0byA9IGMoMCwgMSksIGZyb20gPSByYW5nZShkYXRhJGxhdGl0dWRlLCBuYS5ybSA9IFRSVUUsIGZpbml0ZSA9IFRSVUUpKQogIGRhdGEkbG9uZ2l0dWRlX3NjYWxlZCA9IHJlc2NhbGUoZGF0YSRsb25naXR1ZGUsIHRvID0gYygwLCAxKSwgZnJvbSA9IHJhbmdlKGRhdGEkbG9uZ2l0dWRlLCBuYS5ybSA9IFRSVUUsIGZpbml0ZSA9IFRSVUUpKQogIGRhdGEkYWJzb2x1dGVfbGF0aXR1ZGVfc2NhbGVkID0gYWJzKGRhdGEkbGF0aXR1ZGVfc2NhbGVkKQogIGRhdGEkbnVtYmVyX29mX2NoZWNrbGlzdHNfc3FydCA9IHNxcnQoZGF0YSRudW1iZXJfb2ZfY2hlY2tsaXN0cykKICBkYXRhJG51bWJlcl9vZl9jaGVja2xpc3RzX3NjYWxlZCA9IHJlc2NhbGUoZGF0YSRudW1iZXJfb2ZfY2hlY2tsaXN0c19zcXJ0LCB0byA9IGMoMCwgMSksIGZyb20gPSByYW5nZShkYXRhJG51bWJlcl9vZl9jaGVja2xpc3RzX3NxcnQsIG5hLnJtID0gVFJVRSwgZmluaXRlID0gVFJVRSkpCiAgZGF0YQp9CmBgYAoKCk1lcmxpbgotLS0tLS0tLS0tLS0tLS0tLS0tLS0tCgpgYGB7cn0KbWVybGluIDwtIGxvYWRfZGF0YXNldCgnbWVybGluJykKbWVybGluCmBgYAoKQmlyZGxpZmUKLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQoKYGBge3J9CmJpcmRsaWZlIDwtIGxvYWRfZGF0YXNldCgnYmlyZGxpZmUnKQpiaXJkbGlmZQpgYGAKCmBgYHtyfQpsaWJyYXJ5KCJQZXJmb3JtYW5jZUFuYWx5dGljcyIpCnJjb3JyKGFzLm1hdHJpeChiaXJkbGlmZVssYygnY2xvc2VkX2ZvcmVzdCcsICdjdWx0aXZhdGVkJywgJ2hlcmJhY2VvdXNfdmVnZXRhdGlvbicsICdoZXJiYWNlb3VzX3dldGxhbmQnLCAnb3Blbl9mb3Jlc3QnLCAncGVybWFuZW50X3dhdGVyJywgJ3NocnVicycsICd1cmJhbicpXSwgIG1ldGhvZD0ic3BlYXJtYW4iKSkKYGBgCgpCb3RoCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KCmBgYHtyfQpib3RoIDwtIGxvYWRfZGF0YXNldCgnYm90aCcpCmJvdGgKYGBgCgpFaXRoZXIKLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQoKYGBge3J9CmVpdGhlciA8LSBsb2FkX2RhdGFzZXQoJ2VpdGhlcicpCmVpdGhlcgpgYGAKCmBgYHtyfQpwb3B1bGF0aW9uX2dyb3d0aCA8LSBmdW5jdGlvbihjaXR5X3JvdykgewogIHBvcHVsYXRpb24gPC0gYyhjaXR5X3JvdyRwb3AxOTUwLCBjaXR5X3JvdyRwb3AxOTU1LCBjaXR5X3JvdyRwb3AxOTYwLCBjaXR5X3JvdyRwb3AxOTY1LCBjaXR5X3JvdyRwb3AxOTcwLCBjaXR5X3JvdyRwb3AxOTc1LCBjaXR5X3JvdyRwb3AxOTgwLCBjaXR5X3JvdyRwb3AxOTg1LCBjaXR5X3JvdyRwb3AxOTkwLCBjaXR5X3JvdyRwb3AxOTk1LCBjaXR5X3JvdyRwb3AyMDAwLCBjaXR5X3JvdyRwb3AyMDA1LCBjaXR5X3JvdyRwb3AyMDEwLCBjaXR5X3JvdyRwb3AyMDE1LCBjaXR5X3JvdyRwb3AyMDIwKQogIHllYXJzIDwtIGMoMTk1MCwgMTk1NSwgMTk2MCwgMTk2NSwgMTk3MCwgMTk3NSwgMTk4MCwgMTk4NSwgMTk5MCwgMTk5NSwgMjAwMCwgMjAwNSwgMjAxMCwgMjAxNSwgMjAyMCkKICAKICBtb2RlbCA8LSBsbShwb3B1bGF0aW9uIH4geWVhcnMpCiAgbW9kZWwkY29lZmZpY2llbnRzWzJdCn0KYGBgCgoKYGBge3J9CmNpdHlfZGF0YSA8LSByZWFkX2NzdignZG93bmxvYWRfZGF0YV9faW5wdXRfX2NpdHlfZGF0YS5jc3YnKQpjaXR5X2RhdGEkcmVhbG0gPC0gYXMuZmFjdG9yKGNpdHlfZGF0YSRyZWFsbSkKY2l0eV9kYXRhJGNpdHlfaW5jbHVkZXNfZXN0dWFyeSA8LSBhcy5mYWN0b3IoY2l0eV9kYXRhJGNpdHlfaW5jbHVkZXNfZXN0dWFyeSkKY2l0eV9kYXRhJHJlZ2lvbl8xMDBrbV9pbmNsdWRlc19lc3R1YXJ5IDwtIGFzLmZhY3RvcihjaXR5X2RhdGEkcmVnaW9uXzEwMGttX2luY2x1ZGVzX2VzdHVhcnkpCmNpdHlfZGF0YSRyZWdpb25fNTBrbV9pbmNsdWRlc19lc3R1YXJ5IDwtIGFzLmZhY3RvcihjaXR5X2RhdGEkcmVnaW9uXzUwa21faW5jbHVkZXNfZXN0dWFyeSkKY2l0eV9kYXRhJHJlZ2lvbl8yMGttX2luY2x1ZGVzX2VzdHVhcnkgPC0gYXMuZmFjdG9yKGNpdHlfZGF0YSRyZWdpb25fMjBrbV9pbmNsdWRlc19lc3R1YXJ5KQpjaXR5X2RhdGEkYmlvbWVfbmFtZSA8LSBhcy5mYWN0b3IoY2l0eV9kYXRhJGJpb21lX25hbWUpCgpjaXR5X2RhdGEkcG9wdWxhdGlvbl9ncm93dGggPSAwCgpmb3IoaSBpbiAxOm5yb3coY2l0eV9kYXRhKSkgewogICAgY2l0eV9kYXRhW2ksXSRwb3B1bGF0aW9uX2dyb3d0aCA9IHBvcHVsYXRpb25fZ3Jvd3RoKGNpdHlfZGF0YVtpLF0pCn0KCmNpdHlfZGF0YQpgYGAKCgoK